US Secretary of Defence Chuck Hagel has apologised after he was caught on cameras asking an Indian member of an audience if he was a member of the Taliban.